Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS |
---|---|---|---|---|---|
GID | VARCHAR2(64 CHAR) | No | null | 1 | null |
CREATED_ON | DATE | No | null | 2 | null |
CREATED_BY | VARCHAR2(128 CHAR) | No | null | 3 | null |
MODIFIED_ON | DATE | No | null | 4 | null |
MODIFIED_BY | VARCHAR2(128 CHAR) | No | null | 5 | null |
CHECKSUM | VARCHAR2(128 CHAR) | No | null | 6 | null |
CODE | VARCHAR2(24 CHAR) | No | null | 7 | null |
TITLE | VARCHAR2(256 CHAR) | No | null | 8 | null |
DESCRIPTION | VARCHAR2(4000 BYTE) | No | null | 9 | null |
CATEGORY | VARCHAR2(64 CHAR) | Yes | null | 10 | null |
PAGE | NUMBER(38,0) | No | null | 11 | null |
ACTIVE | VARCHAR2(1 CHAR) | No | ('Y') | 12 | null |
SEQ | NUMBER(38,0) | No | 99 | 13 | null |
DOWNLOAD_QUERY | VARCHAR2(4000 BYTE) | Yes | null | 14 | null |
ROW_COUNT | NUMBER(38,0) | Yes | null | 15 | null |
CONSTRAINT_NAME | CONSTRAINT_TYPE | SEARCH_CONDITION | R_OWNER | R_TABLE_NAME | R_CONSTRAINT_NAME | DELETE_RULE | STATUS | DEFERRABLE | VALIDATED | GENERATED | BAD | RELY | LAST_CHANGE | INDEX_OWNER | INDEX_NAME | INVALID | VIEW_RELATED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CK_REPORT_TYPE_ACTIVE | Check | ACTIVE IN ('Y' ,'N') | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
FK_REPORT_TYPE_CATEGORY | Foreign_Key | null | QART | REPORT_CATEGORY | PK_REPORT_CATEGORY | NO ACTION | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_ACTIVE | Check | "ACTIVE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_CHECKSUM | Check | "CHECKSUM" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_CODE | Check | "CODE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_CREATEDBY | Check | "CREATED_BY" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_CREATEDON | Check | "CREATED_ON" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_DESCRIPTION | Check | "DESCRIPTION" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_GID | Check | "GID" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_MODIFIEDBY | Check | "MODIFIED_BY" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_MODIFIEDON | Check | "MODIFIED_ON" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_PAGE | Check | "PAGE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_SEQ | Check | "SEQ" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
NN_REPORT_TYPE_TITLE | Check | "TITLE" IS NOT NULL | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | null | null | null | null |
PK_REPORT_TYPE | Primary_Key | null | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | QART | PK_REPORT_TYPE | null | null |
UK_REPORT_TYPE_CODE | Unique | null | null | null | null | null | ENABLED | NOT DEFERRABLE | VALIDATED | USER NAME | null | null | 03-APR-23 | QART | UK_REPORT_TYPE_CODE | null | null |
Columns
COLUMN_NAME | COLUMN_POSITION |
---|---|
ACTIVE | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CATEGORY | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
ACTIVE | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CHECKSUM | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CODE | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CREATED_BY | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CREATED_ON | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
DESCRIPTION | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
GID | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
MODIFIED_BY | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
MODIFIED_ON | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
PAGE | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
SEQ | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
TITLE | null |
COLUMN_NAME | COLUMN_POSITION |
---|---|
GID | 1 |
COLUMN_NAME | COLUMN_POSITION |
---|---|
CODE | 1 |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
NAME | VALUE |
---|---|
NUM_ROWS | 33 |
BLOCKS | 20 |
AVG_ROW_LEN | 1181 |
SAMPLE_SIZE | 33 |
LAST_ANALYZED | 25-OCT-24 |
LAST_ANALYZED_SINCE | 25-OCT-24 |
Column Statistics
TRIGGER_NAME | TRIGGER_TYPE | TRIGGER_OWNER | TRIGGERING_EVENT | STATUS | TABLE_NAME |
---|---|---|---|---|---|
REPORT_TYPE_B_IU | BEFORE EACH ROW | QART | INSERT OR UPDATE | ENABLED | REPORT_TYPE |
TRIGGER "QART"."REPORT_TYPE_B_IU" BEFORE INSERT OR UPDATE ON QART.REPORT_TYPE FOR EACH ROW DECLARE l_raw RAW (256) := '00000000'; l_string VARCHAR2 (32767) := NULL; BEGIN IF INSERTING THEN QART_TRIGGER_PROCS.TABLE_INSERT_VALS_GID (:NEW.CREATED_ON, :NEW.CREATED_BY, :NEW.MODIFIED_ON, :NEW.MODIFIED_BY, :NEW.GID); END IF; IF UPDATING THEN QART_TRIGGER_PROCS.TABLE_UPDATE_VALS (:NEW.MODIFIED_ON, :NEW.MODIFIED_BY); END IF; l_string := NVL (:NEW.GID, '') || NVL (TO_CHAR (:NEW.CREATED_ON, 'DDMONYYYYHH24MISS'), '') || NVL (:NEW.CREATED_BY, '') || NVL (TO_CHAR (:NEW.MODIFIED_ON, 'DDMONYYYYHH24MISS'), '') || NVL (:NEW.MODIFIED_BY, '') || NVL (:NEW.CODE, '') || NVL (:NEW.TITLE, '') || NVL (:NEW.DESCRIPTION, '') || NVL (:NEW.CATEGORY, '') || NVL (:NEW.PAGE, '') || NVL (:NEW.ACTIVE, '') || NVL (:NEW.SEQ, ''); IF DBMS_LOB.getlength (l_string) < 1 THEN l_raw := '00000000'; ELSE SELECT standard_hash (l_string, 'SHA256') INTO l_raw FROM DUAL; END IF; :NEW.CHECKSUM := l_raw; END REPORT_TYPE_B_IU;
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | REPORT_TYPE_B_IU | TRIGGER | QART | REPORT_TYPE | TABLE |
QART | QART_REPORT_DOWNLOAD | PACKAGE BODY | QART | REPORT_TYPE | TABLE |
References
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|
NAME | VALUE |
---|---|
CREATED | 03-APR-23 |
LAST_DDL_TIME | 03-APR-23 |
OWNER | QART |
TABLE_NAME | REPORT_TYPE |
TABLESPACE_NAME | SEARCH |
CLUSTER_NAME | null |
IOT_NAME | null |
STATUS | VALID |
PCT_FREE | 10 |
PCT_USED | null |
INI_TRANS | 1 |
MAX_TRANS | 255 |
INITIAL_EXTENT | 65536 |
NEXT_EXTENT | 1048576 |
MIN_EXTENTS | 1 |
MAX_EXTENTS | 2147483645 |
PCT_INCREASE | null |
FREELISTS | null |
FREELIST_GROUPS | null |
LOGGING | YES |
BACKED_UP | N |
NUM_ROWS | 33 |
BLOCKS | 20 |
EMPTY_BLOCKS | 0 |
AVG_SPACE | 0 |
CHAIN_CNT | 0 |
AVG_ROW_LEN | 1181 |
AVG_SPACE_FREELIST_BLOCKS | 0 |
NUM_FREELIST_BLOCKS | 0 |
DEGREE | 1 |
INSTANCES | 1 |
CACHE | N |
TABLE_LOCK | ENABLED |
SAMPLE_SIZE | 33 |
LAST_ANALYZED | 25-OCT-24 |
PARTITIONED | NO |
IOT_TYPE | null |
OBJECT_ID_TYPE | null |
TABLE_TYPE_OWNER | null |
TABLE_TYPE | null |
TEMPORARY | N |
SECONDARY | N |
NESTED | NO |
BUFFER_POOL | DEFAULT |
ROW_MOVEMENT | DISABLED |
GLOBAL_STATS | YES |
USER_STATS | NO |
DURATION | null |
SKIP_CORRUPT | DISABLED |
MONITORING | YES |
CLUSTER_OWNER | null |
DEPENDENCIES | DISABLED |
COMPRESSION | DISABLED |
COMPRESS_FOR | null |
DROPPED | NO |
TABLE_KIND | NORMAL |
PARTITIONING_TYPE | null |
SUBPARTITIONING_TYPE | null |
AUTOLIST | null |
DUPLICATED | N |
SHARDED | N |
COMMENTS | null |
PARTITION_NAME | LAST_ANALYZED | NUM_ROWS | BLOCKS | SAMPLE_SIZE | HIGH_VALUE |
---|
INDEX_OWNER | INDEX_NAME | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | JOIN_INDEX | COLUMNS |
---|---|---|---|---|---|---|---|---|---|
QART | PK_REPORT_TYPE | UNIQUE | VALID | NORMAL | N | NO | null | NO | GID |
QART | UK_REPORT_TYPE_CODE | UNIQUE | VALID | NORMAL | N | NO | null | NO | CODE |
QART | UK_REPORT_TYPE_CATEGORY | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | CATEGORY |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID | COLUMN_EXPRESSION |
---|---|---|---|---|---|---|---|---|---|---|
QART | PK_REPORT_TYPE | QART | REPORT_TYPE | GID | 1 | 256 | 64 | ASC | null | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID | COLUMN_EXPRESSION |
---|---|---|---|---|---|---|---|---|---|---|
QART | UK_REPORT_TYPE_CODE | QART | REPORT_TYPE | CODE | 1 | 96 | 24 | ASC | null | null |
INDEX_OWNER | INDEX_NAME | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | COLUMN_POSITION | COLUMN_LENGTH | CHAR_LENGTH | DESCEND | COLLATED_COLUMN_ID | COLUMN_EXPRESSION |
---|---|---|---|---|---|---|---|---|---|---|
QART | UK_REPORT_TYPE_CATEGORY | QART | REPORT_TYPE | CATEGORY | 1 | 256 | 64 | ASC | null | null |